The difference and choice between MyISAM and InnoDB, detailed summary, performance comparisonJune 25, 2015 21:58:42 read: 1827 more personal Category: MySQL1. MyISAM: The default table type, which is based on the traditional ISAM type, ISAM is an
I. background description:
1. Windows XP environment;
2. the MySQL server version has been installed. You can view it in the following way:
3. The default storage engine is InnoDB and the built-in non-InnoDB plugin;
Requirement: to take advantage
1. MyISAM: The default table type, which is based on the traditional ISAM type, ISAM is an abbreviation for indexed sequential access method (indexed sequential access methods), which is the standard way to store records and files. It is not
1. MyISAM: The default table type, which is based on the traditional ISAM type, ISAM is an abbreviation for indexed sequential access method (indexed sequential access methods), which is the standard way to store records and files. It is not
The content of this article complies with the CC copyright agreement, can be reproduced at will, but must be indicated in the form of Hyperlink original source and author information and copyright statement URL:
When configuring InnoDB parameters today, modify the default configuration. As a result, the started server does not support the InnoDB engine. Plugin 'innodb' registry as a storage engine failed.
Error Log:
InnoDB: Data
MySQL innoDB Storage engine Learning
Master thread has the highest priority in the county. it consists of several loops: Main loop, background loop, flush loop, and suspend loop ). The master thread switches between loop, background loop, flush loop,
You can use show engines, or show plugins;Mysql> Show plugins;+------------+--------+----------------+---------+---------+| Name | Status | Type | Library | License |+------------+--------+----------------+---------+---------+| Binlog | ACTIVE |
This article describes how to get started with the InnoDB engine of MySQL and provides a better summary of the storage structure of InnoDB. For more information, see MySQL development to this day, the InnoDB engine has been an absolute main force.
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.